Database Performance Management in Cloud

Managing large chain of Hotels and ERP database comprises of core areas such as HRMS & PIP.HRMS (Human Resource Management System), which further includes areas such as Soft Joining, Promotion, Transfer, Confirmation, Leave Attendance and Exit, etc. PIP (Payroll Information Portal), wherein employees can view their individual Salary details, submit investment declaration, Reimbursement claim & CTC structuring, etc. Management of Large Chain of Hotels and ERP Database in AWS Cloud involves continuous monitoring with regards to the areas such as Performance of resource usages and optimization techniques relating to the use of PL/SQL. High Availability (HA) of data is accomplished through the Backup and Recovery mechanism and security of the data by Encryption & Decryption mechanism

GST Computation System

We begin by elaborating on the important concept of – cascading effect of taxes. It is also, logically, referred to as “taxes on taxes”. It is simple to illustrate – say A sells goods to B after charging sales tax, and then B re-sells those goods to C after charging sales tax. While B was computing his sales tax liability, he also included the sales tax paid on previous purchase, which is how it becomes a tax on tax. The GST is introduced to combat this problem, among many others. The main purpose of our software will making the invoices task easy and handles all user GST invoicing/billing needs. Customer will select the product and proceed for the invoices by retailer. Retailer will enter the product detail in system and amount of the product. System will select the Tax percentage base on the particular 2product and calculate the actual amount and tax. It will show the total amount of product including GST rates

SARS-CoV-2 (COVID-19) as a possible risk factor for neurodevelopmental disorders

Pregnant women constitute one of the most vulnerable populations to be affected by severe acute respiratory syndrome coronavirus 2 (SARS-CoV-2) infection, the cause of coronavirus disease 2019. SARS-CoV-2 infection during pregnancy could negatively impact fetal brain development via multiple mechanisms. Accumulating evidence indicates that mother to fetus transmission of SARS-CoV-2 does occur, albeit rarely. When it does occur, there is a potential for neuroinvasion via immune cells, retrograde axonal transport, and olfactory bulb and lymphatic pathways. In the absence of maternal to fetal transmission, there is still the potential for negative neurodevelopmental outcomes as a consequence of disrupted placental development and function leading to preeclampsia, preterm birth, and intrauterine growth restriction. In addition, maternal immune activation may lead to hypomyelination, microglial activation, white matter damage, and reduced neurogenesis in the developing fetus. Moreover, maternal immune activation can disrupt the maternal or fetal hypothalamic-pituitary-adrenal (HPA) axis leading to altered neurodevelopment. Finally, pro-inflammatory cytokines can potentially alter epigenetic processes within the developing brain. In this review, we address each of these potential mechanisms. We propose that SARS-CoV-2 could lead to neurodevelopmental disorders in a subset of pregnant women and that long-term studies are warranted

Quality of life of Chronic Kidney Disease patients attending Nephrology OPD of a tertiary care centre in Western Maharashtra

Introduction: Kidney disease is a global public health problem affecting approximately 750 million people worldwide. Patients of Chronic Kidney Disease (CKD) face bio-psychological stressors affecting their quality of life (QoL). CKD patients with low QoL have shown considerably high mortality. Assessing QoL can help in planning holistic medical care for these patients and improve disease outcomes. The present study has been conducted with the objective to assess QoL in CKD patients. Objective: To assess QoL of CKD patients attending Nephrology OPD of a tertiary care Government centre in Western Maharashtra. Methodology: It was a cross-sectional descriptive study conducted in Nephrology OPD of a tertiary care hospital in Western Maharashtra. Pre-tested Research and Development Corporation 36-item Health Survey Questionnaire was self- administered to CKD patients and QoL scores were calculated. All patients attending Nephrology OPD were included in the study group from July to Oct 2019. Data was analysed using SPSS version 20.0. Results: The study included 70 patients with moderate to advanced CKD irrespective of status of treatment being received. Diabetes Mellitus was found to be the most common cause of CKD followed by Hypertension. The mean overall QoL score was 38.9+8.2. The mean Mental Component Summary (MCS) score (29.2+7.8, 95%C.I.: 21.4–37.0 was significantly lower than the mean Physical Component Summary (PCS) score (48.5 + 9.5, 95% C.I.: 39.0-58.0, p<0.001). Conclusion: Patients with CKD have lower MCS compared to PCS

Mapping child growth failure across low- and middle-income countries

Child growth failure (CGF), manifested as stunting, wasting, and underweight, is associated with high 5 mortality and increased risks of cognitive, physical, and metabolic impairments. Children in low- and middle-income countries (LMICs) face the highest levels of CGF globally. Here we illustrate national and subnational variation of under-5 CGF indicators across LMICs, providing 2000–2017 annual estimates mapped at a high spatial resolution and aggregated to policy-relevant administrative units and national levels. Despite remarkable declines over the study period, many LMICs remain far from the World Health 10 Organization’s ambitious Global Nutrition Targets to reduce stunting by 40% and wasting to less than 5% by 2025. Large disparities in prevalence and rates of progress exist across regions, countries, and within countries; our maps identify areas where high prevalence persists even within nations otherwise succeeding in reducing overall CGF prevalence. By highlighting where subnational disparities exist and the highest-need populations reside, these geospatial estimates can support policy-makers in planning locally 15 tailored interventions and efficient directing of resources to accelerate progress in reducing CGF and its health implications

Mapping disparities in education across low- and middle-income countries

Analyses of the proportions of individuals who have completed key levels of schooling across all low- and middle-income countries from 2000 to 2017 reveal inequalities across countries as well as within populations. Educational attainment is an important social determinant of maternal, newborn, and child health(1-3). As a tool for promoting gender equity, it has gained increasing traction in popular media, international aid strategies, and global agenda-setting(4-6). The global health agenda is increasingly focused on evidence of precision public health, which illustrates the subnational distribution of disease and illness(7,8); however, an agenda focused on future equity must integrate comparable evidence on the distribution of social determinants of health(9-11). Here we expand on the available precision SDG evidence by estimating the subnational distribution of educational attainment, including the proportions of individuals who have completed key levels of schooling, across all low- and middle-income countries from 2000 to 2017. Previous analyses have focused on geographical disparities in average attainment across Africa or for specific countries, but-to our knowledge-no analysis has examined the subnational proportions of individuals who completed specific levels of education across all low- and middle-income countries(12-14). By geolocating subnational data for more than 184 million person-years across 528 data sources, we precisely identify inequalities across geography as well as within populations.Peer reviewe

Population and fertility by age and sex for 195 countries and territories, 1950–2017: a systematic analysis for the Global Burden of Disease Study 2017

Background: Population estimates underpin demographic and epidemiological research and are used to track progress on numerous international indicators of health and development. To date, internationally available estimates of population and fertility, although useful, have not been produced with transparent and replicable methods and do not use standardised estimates of mortality. We present single-calendar year and single-year of age estimates of fertility and population by sex with standardised and replicable methods. Methods: We estimated population in 195 locations by single year of age and single calendar year from 1950 to 2017 with standardised and replicable methods. We based the estimates on the demographic balancing equation, with inputs of fertility, mortality, population, and migration data. Fertility data came from 7817 location-years of vital registration data, 429 surveys reporting complete birth histories, and 977 surveys and censuses reporting summary birth histories. We estimated age-specific fertility rates (ASFRs; the annual number of livebirths to women of a specified age group per 1000 women in that age group) by use of spatiotemporal Gaussian process regression and used the ASFRs to estimate total fertility rates (TFRs; the average number of children a woman would bear if she survived through the end of the reproductive age span [age 10–54 years] and experienced at each age a particular set of ASFRs observed in the year of interest). Because of sparse data, fertility at ages 10–14 years and 50–54 years was estimated from data on fertility in women aged 15–19 years and 45–49 years, through use of linear regression. Age-specific mortality data came from the Global Burden of Diseases, Injuries, and Risk Factors Study (GBD) 2017 estimates. Data on population came from 1257 censuses and 761 population registry location-years and were adjusted for underenumeration and age misreporting with standard demographic methods. Migration was estimated with the GBD Bayesian demographic balancing model, after incorporating information about refugee migration into the model prior. Final population estimates used the cohort-component method of population projection, with inputs of fertility, mortality, and migration data. Population uncertainty was estimated by use of out-of-sample predictive validity testing. With these data, we estimated the trends in population by age and sex and in fertility by age between 1950 and 2017 in 195 countries and territories. Findings: From 1950 to 2017, TFRs decreased by 49\ub74% (95% uncertainty interval [UI] 46\ub74–52\ub70). The TFR decreased from 4\ub77 livebirths (4\ub75–4\ub79) to 2\ub74 livebirths (2\ub72–2\ub75), and the ASFR of mothers aged 10–19 years decreased from 37 livebirths (34–40) to 22 livebirths (19–24) per 1000 women. Despite reductions in the TFR, the global population has been increasing by an average of 83\ub78 million people per year since 1985. The global population increased by 197\ub72% (193\ub73–200\ub78) since 1950, from 2\ub76 billion (2\ub75–2\ub76) to 7\ub76 billion (7\ub74–7\ub79) people in 2017; much of this increase was in the proportion of the global population in south Asia and sub-Saharan Africa. The global annual rate of population growth increased between 1950 and 1964, when it peaked at 2\ub70%; this rate then remained nearly constant until 1970 and then decreased to 1\ub71% in 2017. Population growth rates in the southeast Asia, east Asia, and Oceania GBD super-region decreased from 2\ub75% in 1963 to 0\ub77% in 2017, whereas in sub-Saharan Africa, population growth rates were almost at the highest reported levels ever in 2017, when they were at 2\ub77%. The global average age increased from 26\ub76 years in 1950 to 32\ub71 years in 2017, and the proportion of the population that is of working age (age 15–64 years) increased from 59\ub79% to 65\ub73%. At the national level, the TFR decreased in all countries and territories between 1950 and 2017; in 2017, TFRs ranged from a low of 1\ub70 livebirths (95% UI 0\ub79–1\ub72) in Cyprus to a high of 7\ub71 livebirths (6\ub78–7\ub74) in Niger. The TFR under age 25 years (TFU25; number of livebirths expected by age 25 years for a hypothetical woman who survived the age group and was exposed to current ASFRs) in 2017 ranged from 0\ub708 livebirths (0\ub707–0\ub709) in South Korea to 2\ub74 livebirths (2\ub72–2\ub76) in Niger, and the TFR over age 30 years (TFO30; number of livebirths expected for a hypothetical woman ageing from 30 to 54 years who survived the age group and was exposed to current ASFRs) ranged from a low of 0\ub73 livebirths (0\ub73–0\ub74) in Puerto Rico to a high of 3\ub71 livebirths (3\ub70–3\ub72) in Niger. TFO30 was higher than TFU25 in 145 countries and territories in 2017. 33 countries had a negative population growth rate from 2010 to 2017, most of which were located in central, eastern, and western Europe, whereas population growth rates of more than 2\ub70% were seen in 33 of 46 countries in sub-Saharan Africa. In 2017, less than 65% of the national population was of working age in 12 of 34 high-income countries, and less than 50% of the national population was of working age in Mali, Chad, and Niger. Interpretation: Population trends create demographic dividends and headwinds (ie, economic benefits and detriments) that affect national economies and determine national planning needs. Although TFRs are decreasing, the global population continues to grow as mortality declines, with diverse patterns at the national level and across age groups. To our knowledge, this is the first study to provide transparent and replicable estimates of population and fertility, which can be used to inform decision making and to monitor progress. Funding: Bill &amp; Melinda Gates Foundation